Quiz 15
Question # 1
Which of the following actions are possible with mysqldump tool?
A)
It can be used to make a backup of a single database in the MySQL server.
B)
It can be used to make a backup of all databases in the MySQL server in one go.
C)
It can be used to make a backup of selected tables from a database.
D)
It can be used to make a backup of database structure only.
E)
It can be used to make a backup of data only.
Question # 2
Which statements are true for MySQL TIMESTAMP datatype?
A)
The format of TIMESTAMP is YYYY-MM-DD HH:MM:SS.
B)
TIMESTAMP data type is used to store the combination of date and time value which is 18 characters long.
C)
TIMESTAMP can store data from ‘1970-01-01 00:00:01’ UTC to ‘2038-01-19 03:14:07’ UTC.
D)
MySQL automatically converts the TIMESTAMP value from your connection’s time zone to UTC for storing.
E)
TIMESTAMP represents the date and time value by using 32-bits integers.
Question # 3
In MySQL which function can be used to evaluate the first argument for NULL value and return the second argument if the first argument is NULL?
A)
NVL( arg1 , arg2 )
B)
IFNULL( arg1, arg2)
Question # 4
What will be the output of executing the following statement:
SELECT IFNULL('',1);
A)
‘’
B)
1
C)
Error
Question # 5
How can you display the current date and time of the server?
A)
NOW()
B)
CURDATE()
C)
SYSDATE()
D)
DATE(NOW())
